UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZP2deoKjZEJGo9IWUlzredrYhKOnJTfk8XgjUznH/94='
WHERE
key_id = '37e88f854b9d17c141a16e506a866417f2531f6f81d140b4e243116ca06804c0'
AND (
token = 'ZP2deoKjZEJGo9IWUlzredrYhKOnJTfk8XgjUznH/94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)