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