UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oPk1QMqKLN+rhAVqA2Nbd3maBz2JSgyidopEKJbhd3s='
WHERE
key_id = 'b2e1afae2911e8f72dba9cf88ef9a28bfd0c0f6df845eca1a743f3d68c7605fd'
AND (
token = 'oPk1QMqKLN+rhAVqA2Nbd3maBz2JSgyidopEKJbhd3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)