UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z/7av1AbmWj/qARN3GVb6MSx2fECmatg6KxEqqGSFaE='
WHERE
key_id = '3a71d6ebe53d3b868b16a40c9398102a1743b04cd97fbbf29f41fbae8ad0c45d'
AND (
token = 'z/7av1AbmWj/qARN3GVb6MSx2fECmatg6KxEqqGSFaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)