UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JgB6oMIzKLvNiIYJhOHSGyGg8alp1a/g623O6jfrOKg='
WHERE
key_id = '958f82be24cabf7c5e022ade6e602db2d08792c0566b38841749debcc522ba4e'
AND (
token = 'JgB6oMIzKLvNiIYJhOHSGyGg8alp1a/g623O6jfrOKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)