UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3t4vyGnnWIAUuyA34ZgU8OdC7cdINYfsWkMaUvwiycw='
WHERE
key_id = '808dab86e6a001e8552f8b2bcce5025f268bbe171073065b878f0769dac8dedb'
AND (
token = '3t4vyGnnWIAUuyA34ZgU8OdC7cdINYfsWkMaUvwiycw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)