UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Oc0GZ7/9WeIKX2GYKl+s7ivFf38k+AKWFDnqKfo6PH4='
WHERE
key_id = 'fdfbc97439d7c23fbd302579ca3a0dc64eea3f220b2add7a0d7f7f1efc0e624b'
AND (
token = 'Oc0GZ7/9WeIKX2GYKl+s7ivFf38k+AKWFDnqKfo6PH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)