UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bMDqweiZIVlYb6RZx+H+v9k6iD2yqt6QEig7yR6HWn8='
WHERE
key_id = 'bad8103031576f10ad644ceca2cc96887ed3f9b27e5c49ad6b5224fdb770edc7'
AND (
token = 'bMDqweiZIVlYb6RZx+H+v9k6iD2yqt6QEig7yR6HWn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)