UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OSPNHarC+g66lwZHrEA1eKYa/J55gsdMK9H9x80htIg='
WHERE
key_id = '1a20060aa15d291edc2de823eaae2961d8e75abb50497c593c171c134b2fee1a'
AND (
token = 'OSPNHarC+g66lwZHrEA1eKYa/J55gsdMK9H9x80htIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)