UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B0FUHs7jbksDJQwcxXv6x0T1AZ6aJklcXOkJ47hVYTk='
WHERE
key_id = '4f6885ab83b7b0a3407daa683a1b9a8e669e413abcb937d15ce764f03caad522'
AND (
token = 'B0FUHs7jbksDJQwcxXv6x0T1AZ6aJklcXOkJ47hVYTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)