UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8xnT8H2+LCRNg/Cv714cd4Od5OW9+Y7awZzRRUL3eUI='
WHERE
key_id = '06abf50ad5a95734ee6ac4e19d8b6d1955fa839525a580776c9d496a68c55384'
AND (
token = '8xnT8H2+LCRNg/Cv714cd4Od5OW9+Y7awZzRRUL3eUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)