UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gG4t3d9i/vPaK8wuAqNAwZFVVW9z0W8g3mnY2vccr/4='
WHERE
key_id = '6b504b474894dfe468be15c1ee18ba91ef2aa73bd1ede833891676800ab9133b'
AND (
token = 'gG4t3d9i/vPaK8wuAqNAwZFVVW9z0W8g3mnY2vccr/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)