UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a3hbbfGbDH9CPi8b3cZZ+ICIs++DkA08ZwOUFXl3nAA='
WHERE
key_id = '567c6d69c0e3ebc60daab5dac764a8ec4a93405c485153d6dd0f7615c9a8ea6b'
AND (
token = 'a3hbbfGbDH9CPi8b3cZZ+ICIs++DkA08ZwOUFXl3nAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)