UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPBY+3d3VJ1YCW6/bi/CdAMlihjwoZPQrodiGAqLZiQ='
WHERE
key_id = 'f91b8af3b7898c71d27416f73964e19e80d78043a43fbc76e8c133ea640488fc'
AND (
token = 'gPBY+3d3VJ1YCW6/bi/CdAMlihjwoZPQrodiGAqLZiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)