UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '30hnmGbUScYuVHCv34IJPI57ummH4E409bGBjhTYSek='
WHERE
key_id = 'ed329b0ec1f88bbd395e3cd16c9e3b29a1df4fa61a49d0cb92fd70d7c48d0973'
AND (
token = '30hnmGbUScYuVHCv34IJPI57ummH4E409bGBjhTYSek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)