UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B4a9+gl7RE43j8qUMLIpuTzaAY4LSyTCJWb1nrtnioQ='
WHERE
key_id = '3161ef6822b37738289510ddf611106e96d90c26e3d477b63531ad0afc595bfb'
AND (
token = 'B4a9+gl7RE43j8qUMLIpuTzaAY4LSyTCJWb1nrtnioQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)