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