UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PUaAHYaooeVO1auCiIYW57yDWDhFOomma3MxdZflstI='
WHERE
key_id = '8b299179624bfe7c256966e3282b7b0769dda6777fb07d319f42fba15667bcc0'
AND (
token = 'PUaAHYaooeVO1auCiIYW57yDWDhFOomma3MxdZflstI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)