UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZqKiUsRiXpHO5F2n7v5Ryn6PPpHLM00MysPnVVfVvfw='
WHERE
key_id = 'eb86482cf50917264efd0da53afe62fe40df570c752705434ce0fe05c09a6b71'
AND (
token = 'ZqKiUsRiXpHO5F2n7v5Ryn6PPpHLM00MysPnVVfVvfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)