UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9Jg8kLggR+55pLokX8/74Bv0Vwt5EgmRILROrzePxY='
WHERE
key_id = 'a272d04aeab8f7f55ff756547392bb0fd18b59b737b152cf85ee3b7b29901b34'
AND (
token = 'U9Jg8kLggR+55pLokX8/74Bv0Vwt5EgmRILROrzePxY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)