UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KshcN4z+8SrrZF0hD0z08KaZ09qrgzMAw6w4MqRqPfw='
WHERE
key_id = '30e15324711c0ea96eb5ef746cecf16c4254ea31a4411fc8d970043bfeabb71b'
AND (
token = 'KshcN4z+8SrrZF0hD0z08KaZ09qrgzMAw6w4MqRqPfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)