UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3QOUV29lGBD7MWS6JZWjyjOIuhJBnxCfNcoPTS2Rkvg='
WHERE
key_id = '59dc46e03bf61202652c7b922b278af63305aefbc56c536b3520f0db33d91e59'
AND (
token = '3QOUV29lGBD7MWS6JZWjyjOIuhJBnxCfNcoPTS2Rkvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)