UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZiFOLPcPyWg57FKdgidMhfmnrxZmj6jLPNdWnSM/4sg='
WHERE
key_id = '76a7143bfabb1f875145eccb187c6e7afc5d12d5836b11a2a547ac7ac05611ca'
AND (
token = 'ZiFOLPcPyWg57FKdgidMhfmnrxZmj6jLPNdWnSM/4sg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)