UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xjciP1i7MtWueY55hhRRLXQpVL8FOFi1dAuJsZu9x30='
WHERE
key_id = 'b1bb1c97269db779c37abf79cbb42b1752daf1164c85b5242df216b045bddd9f'
AND (
token = 'xjciP1i7MtWueY55hhRRLXQpVL8FOFi1dAuJsZu9x30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)