UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bqljhrqawNCeeso9CnCAcQl6M5cBIgH4RN2wBS2Cxi8='
WHERE
key_id = 'a828dcff5c4cbabac2d3231c42f8455662c2cef2738192cb86552948eb6efb21'
AND (
token = 'bqljhrqawNCeeso9CnCAcQl6M5cBIgH4RN2wBS2Cxi8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)