UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LLls/bA1TD4tGj647tim6Shn/OM/F8bI2ZIdSLI8zgU='
WHERE
key_id = '7cf4dd6afbb179e9ca388219d7e1ab03cfb18987fc3628883693a0dbae916dfe'
AND (
token = 'LLls/bA1TD4tGj647tim6Shn/OM/F8bI2ZIdSLI8zgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)