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