UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xvtWqHbLgMprFbohc9AX5gIo7eESqouOz2b2hmI+RY0='
WHERE
key_id = '1f27ab62c21694091d3c7fce79e9ec283259bceccd683ca516a5ce408c2492e1'
AND (
token = 'xvtWqHbLgMprFbohc9AX5gIo7eESqouOz2b2hmI+RY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)