UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'URqe9A7k3YUtVrct+OyUyi82fFz3HPF8DXqwJmI1QSM='
WHERE
key_id = '47d29e677e876ae592e55850e592963468f0a218c0130dfec5edbe96ae563c4f'
AND (
token = 'URqe9A7k3YUtVrct+OyUyi82fFz3HPF8DXqwJmI1QSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)