UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o3lDEFZpBsv39kniGG4eYKJ5S+0jhH/nxpLa8hyifAw='
WHERE
key_id = 'c9526ab1f0948706ef19711c41cf5538ba71f90e1e0a2851d1d29c58431b937a'
AND (
token = 'o3lDEFZpBsv39kniGG4eYKJ5S+0jhH/nxpLa8hyifAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)