UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cKH7OYqQ7QSOuF1Gkg20oiib+gvZlgxTSXaZX+VtGrA='
WHERE
key_id = '5f3075a6857b0d623a360b24793365bc14301047a745351ec4178524bffd7ea3'
AND (
token = 'cKH7OYqQ7QSOuF1Gkg20oiib+gvZlgxTSXaZX+VtGrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)