UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oPiprIIVy5WUUIJwp3vbDzlXGyjS1Ykb7iYY1VeY8hQ='
WHERE
key_id = '6a040c16b853e7b35df0ef765a7ea90dba9321de88ed694058ab49bd0a137038'
AND (
token = 'oPiprIIVy5WUUIJwp3vbDzlXGyjS1Ykb7iYY1VeY8hQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)